INSERT INTO CLIENT VALUES(idClient_seq.nextVal,'1111','11112222333344445555');
INSERT INTO CLIENT VALUES(idClient_seq.nextVal,'2222','22223333444455556666');
INSERT INTO CLIENT VALUES(idClient_seq.nextVal,'3333','33334444555566667777');
INSERT INTO CLIENT VALUES(idClient_seq.nextVal,'4444','44445555666677778888');
INSERT INTO CLIENT VALUES(idClient_seq.nextVal,'5555','55556666777788889999');
INSERT INTO CLIENT VALUES(idClient_seq.nextVal,'6666','66667777888899991111');

INSERT INTO CLIENTABO VALUES(5,'Seuzaret','Bruno',TO_DATE('01/10/2000','dd/mm/yyyy'),'H',10,'Rue des arts et metiers','38000','Grenoble',TO_DATE('21/01/2016','dd/mm/yyyy'),0);
INSERT INTO CLIENTABO VALUES(2,'Baret','Sylvain',TO_DATE('14/06/1999', 'dd/mm/yyyy'),'H',22,'Rue des Bergers','38000','Grenoble',TO_DATE('07/10/2015', 'dd/mm/yyyy'),0);
INSERT INTO CLIENTABO VALUES(3,'Zhu','Chongyang',TO_DATE('09/05/1997', 'dd/mm/yyyy'),'H',10,'Rue Colonel Dumont','38000','Grenoble',TO_DATE('03/11/2015', 'dd/mm/yyyy'),0);
INSERT INTO CLIENTABO VALUES(4,'Maille','Olivier',TO_DATE('09/09/1990', 'dd/mm/yyyy'),'H',4,'Rue Pierre Brossolette','38400','Saint Martin Heres',TO_DATE('22/11/2015', 'dd/mm/yyyy'),0);

INSERT INTO CLIENTTICKET VALUES (6,'',TO_DATE('19/01/2015', 'dd/mm/yyyy'));
INSERT INTO CLIENTTICKET VALUES (7,'',TO_DATE('20/01/2015', 'dd/mm/yyyy'));

INSERT INTO VELO VALUES(idVelo_seq.nextVal,'NEXUS',TO_DATE('01/10/2013', 'dd/mm/yyyy'),1,'Bornette');
INSERT INTO VELO VALUES(idVelo_seq.nextVal,'NEXUS',TO_DATE('01/10/2013', 'dd/mm/yyyy'),1,'Bornette');
INSERT INTO VELO VALUES(idVelo_seq.nextVal,'NEXUS',TO_DATE('01/10/2013', 'dd/mm/yyyy'),1,'Bornette');
INSERT INTO VELO VALUES(idVelo_seq.nextVal,'NEXUS',TO_DATE('01/10/2013', 'dd/mm/yyyy'),1,'Bornette');
INSERT INTO VELO VALUES(idVelo_seq.nextVal,'NEXUS',TO_DATE('01/10/2013', 'dd/mm/yyyy'),1,'Bornette');
INSERT INTO VELO VALUES(idVelo_seq.nextVal,'NEXUS',TO_DATE('01/10/2013', 'dd/mm/yyyy'),1,'Bornette');
INSERT INTO VELO VALUES(idVelo_seq.nextVal,'NEXUS',TO_DATE('01/10/2013', 'dd/mm/yyyy'),1,'Bornette');
INSERT INTO VELO VALUES(idVelo_seq.nextVal,'NEXUS',TO_DATE('01/10/2013', 'dd/mm/yyyy'),1,'Bornette');
INSERT INTO VELO VALUES(idVelo_seq.nextVal,'NEXUS',TO_DATE('01/10/2013', 'dd/mm/yyyy'),1,'Bornette');
INSERT INTO VELO VALUES(idVelo_seq.nextVal,'NEXUS',TO_DATE('01/10/2013', 'dd/mm/yyyy'),1,'Bornette');
INSERT INTO VELO VALUES(idVelo_seq.nextVal,'NEXUS',TO_DATE('01/10/2013', 'dd/mm/yyyy'),1,'Bornette');
INSERT INTO VELO VALUES(idVelo_seq.nextVal,'NEXUS',TO_DATE('01/10/2013', 'dd/mm/yyyy'),1,'Bornette');
INSERT INTO VELO VALUES(idVelo_seq.nextVal,'NEXUS',TO_DATE('01/10/2013', 'dd/mm/yyyy'),1,'Bornette');
INSERT INTO VELO VALUES(idVelo_seq.nextVal,'NEXUS',TO_DATE('01/10/2013', 'dd/mm/yyyy'),1,'Bornette');
INSERT INTO VELO VALUES(idVelo_seq.nextVal,'NEXUS',TO_DATE('01/10/2013', 'dd/mm/yyyy'),1,'Bornette');
INSERT INTO VELO VALUES(idVelo_seq.nextVal,'NEXUS',TO_DATE('01/10/2013', 'dd/mm/yyyy'),1,'Bornette');

INSERT INTO STATION (IDSTATION,NUMRUESTATION,NOMRUESTATION,CPSTATION,NOMVILLESTATION)VALUES (idStation_seq.nextVal,22,'Rue Hoche','38000','Grenoble');
INSERT INTO STATION (IDSTATION,NUMRUESTATION,NOMRUESTATION,CPSTATION,NOMVILLESTATION)VALUES (idStation_seq.nextVal,10,'Rue Desaix','38000','Grenoble');
INSERT INTO STATION (IDSTATION,NUMRUESTATION,NOMRUESTATION,CPSTATION,NOMVILLESTATION)VALUES (idStation_seq.nextVal,22,'Rue General Ferrie','38000','Grenoble');
INSERT INTO STATION (IDSTATION,NUMRUESTATION,NOMRUESTATION,CPSTATION,NOMVILLESTATION)VALUES (idStation_seq.nextVal,1,'Rue Alexandre Dumas','38000','Grenoble');

INSERT INTO BORNETTE (IDBORNETTE,IDSTATION,IDVELO,ETATBORNETTE) VALUES (idBornette_seq.nextVal,2,null,1);
INSERT INTO BORNETTE (IDBORNETTE,IDSTATION,IDVELO,ETATBORNETTE) VALUES (idBornette_seq.nextVal,2,null,1);
INSERT INTO BORNETTE (IDBORNETTE,IDSTATION,IDVELO,ETATBORNETTE) VALUES (idBornette_seq.nextVal,2,0007,1);
INSERT INTO BORNETTE (IDBORNETTE,IDSTATION,IDVELO,ETATBORNETTE) VALUES (idBornette_seq.nextVal,2,0008,1);
INSERT INTO BORNETTE (IDBORNETTE,IDSTATION,IDVELO,ETATBORNETTE) VALUES (idBornette_seq.nextVal,3,0009,1);
INSERT INTO BORNETTE (IDBORNETTE,IDSTATION,IDVELO,ETATBORNETTE) VALUES (idBornette_seq.nextVal,3,0010,1);
INSERT INTO BORNETTE (IDBORNETTE,IDSTATION,IDVELO,ETATBORNETTE) VALUES (idBornette_seq.nextVal,3,0011,1);
INSERT INTO BORNETTE (IDBORNETTE,IDSTATION,IDVELO,ETATBORNETTE) VALUES (idBornette_seq.nextVal,3,0012,1);
INSERT INTO BORNETTE (IDBORNETTE,IDSTATION,IDVELO,ETATBORNETTE) VALUES (idBornette_seq.nextVal,4,0013,1);
INSERT INTO BORNETTE (IDBORNETTE,IDSTATION,IDVELO,ETATBORNETTE) VALUES (idBornette_seq.nextVal,4,0014,1);
INSERT INTO BORNETTE (IDBORNETTE,IDSTATION,IDVELO,ETATBORNETTE) VALUES (idBornette_seq.nextVal,4,0015,1);
INSERT INTO BORNETTE (IDBORNETTE,IDSTATION,IDVELO,ETATBORNETTE) VALUES (idBornette_seq.nextVal,4,0016,1);

INSERT INTO CLASSIFICATION VALUES(idClassif_seq.nextVal,2,'Vplus',TO_DATE('21/01/2015 07:00:00','dd/mm/yyyy hh24:mi:ss'),TO_DATE('21/01/2015 19:00:00','dd/mm/yyyy hh24:mi:ss'));
INSERT INTO CLASSIFICATION VALUES(idClassif_seq.nextVal,3,'Vplus',TO_DATE('26/01/2015 07:00:00','dd/mm/yyyy hh24:mi:ss'),TO_DATE('29/01/2015 19:00:00','dd/mm/yyyy hh24:mi:ss'));

INSERT INTO LOCATIONVELO VALUES (idLocation_seq.nextVal,2,3,2,2,TO_DATE('21/01/2015 07:52:00', 'dd/mm/yyyy hh24:mi:ss'),TO_DATE('21/01/2015 07:59:00', 'dd/mm/yyyy hh24:mi:ss'),1.5,1);
INSERT INTO LOCATIONVELO VALUES (idLocation_seq.nextVal,2,3,2,3,TO_DATE('21/01/2015 07:00:00', 'dd/mm/yyyy hh24:mi:ss'),TO_DATE('21/01/2015 09:00:00', 'dd/mm/yyyy hh24:mi:ss'),1.5,1);
INSERT INTO LOCATIONVELO VALUES (idLocation_seq.nextVal,3,2,2,4,TO_DATE('21/01/2015 07:00:00', 'dd/mm/yyyy hh24:mi:ss'),TO_DATE('21/01/2015 09:00:00', 'dd/mm/yyyy hh24:mi:ss'),1.5,1);
INSERT INTO LOCATIONVELO VALUES (idLocation_seq.nextVal,3,2,2,5,TO_DATE('21/01/2015 07:00:00', 'dd/mm/yyyy hh24:mi:ss'),TO_DATE('21/01/2015 09:00:00', 'dd/mm/yyyy hh24:mi:ss'),1.5,1);
INSERT INTO LOCATIONVELO VALUES (idLocation_seq.nextVal,3,5,2,6,TO_DATE('21/01/2015 07:00:00', 'dd/mm/yyyy hh24:mi:ss'),TO_DATE('21/01/2015 09:00:00', 'dd/mm/yyyy hh24:mi:ss'),1.5,1);
INSERT INTO LOCATIONVELO VALUES (idLocation_seq.nextVal,5,2,2,7,TO_DATE('21/01/2015 07:00:00', 'dd/mm/yyyy hh24:mi:ss'),TO_DATE('21/01/2015 09:00:00', 'dd/mm/yyyy hh24:mi:ss'),1.5,1);

INSERT INTO TYPETACHE VALUES(idTypeTache_seq.nextVal,'Deplacer');
INSERT INTO TYPETACHE VALUES(idTypeTache_seq.nextVal,'Verifier');

INSERT INTO RESERVATION VALUES (idReservation_seq.nextVal,2,4,sysdate,TO_DATE('01/10/2010', 'dd/mm/yyyy'));

INSERT INTO VEHICULE VALUES(1,TO_DATE('01/10/2010', 'dd/mm/yyyy'),10,'TRAFFIC');
INSERT INTO VEHICULE VALUES(2,TO_DATE('01/11/2010', 'dd/mm/yyyy'),10,'TRAFFIC');
INSERT INTO VEHICULE VALUES(3,TO_DATE('01/12/2010', 'dd/mm/yyyy'),10,'TRANSPORTER');
INSERT INTO VEHICULE VALUES(4,TO_DATE('01/07/2011', 'dd/mm/yyyy'),10,'TRAFFIC');

INSERT INTO ROUTINES VALUES(idRoutine_seq.nextVal,1,TO_DATE('22/01/2015', 'dd/mm/yyyy'));
INSERT INTO ROUTINES VALUES(idRoutine_seq.nextVal,2,TO_DATE('23/01/2015', 'dd/mm/yyyy'));
INSERT INTO ROUTINES VALUES(idRoutine_seq.nextVal,3,TO_DATE('22/01/2015', 'dd/mm/yyyy'));
INSERT INTO ROUTINES VALUES(idRoutine_seq.nextVal,1,TO_DATE('23/01/2015', 'dd/mm/yyyy'));

INSERT INTO TACHE(IDTACHE,IDSTATION,IDROUTINES,SEQTACHE,IDTYPETACHE,TACHEANNULE,NOMBREVELO) VALUES(idTache_seq.nextVal,2,2,2,2,0,1);
INSERT INTO TACHE(IDTACHE,IDSTATION,IDROUTINES,SEQTACHE,IDTYPETACHE,TACHEANNULE,NOMBREVELO) VALUES(idTache_seq.nextVal,4,2,3,2,0,1);
INSERT INTO TACHE(IDTACHE,IDSTATION,IDROUTINES,SEQTACHE,IDTYPETACHE,TACHEANNULE,NOMBREVELO) VALUES(idTache_seq.nextVal,3,2,4,2,0,1);
INSERT INTO TACHE(IDTACHE,IDSTATION,IDROUTINES,SEQTACHE,IDTYPETACHE,TACHEANNULE,NOMBREVELO) VALUES(idTache_seq.nextVal,4,3,2,3,0,1);
INSERT INTO TACHE(IDTACHE,IDSTATION,IDROUTINES,SEQTACHE,IDTYPETACHE,TACHEANNULE,NOMBREVELO) VALUES(idTache_seq.nextVal,2,3,3,3,0,1);

INSERT INTO ESTREGULEPAR  VALUES(2,2);
INSERT INTO ESTREGULEPAR  VALUES(2,3);
INSERT INTO ESTREGULEPAR  VALUES(3,4);
INSERT INTO ESTREGULEPAR  VALUES(3,5);
INSERT INTO ESTREGULEPAR  VALUES(3,6);
INSERT INTO ESTREGULEPAR  VALUES(3,7);
INSERT INTO ESTREGULEPAR  VALUES(3,8);













